[]
Sets conditional formatting for a specified cell on the sheet based on specified rules.
public void SetConditionalFormatting(int row, int column, params IConditionalFormattingRule[] rules)
Public Sub SetConditionalFormatting(row As Integer, column As Integer, ParamArray rules As IConditionalFormattingRule())
Type | Name | Description |
---|---|---|
int | row | Row index |
int | column | Column index |
IConditionalFormattingRule[] | rules | Rules to apply for the specified cell |
Sets conditional formatting for a specified cell on the sheet based on specified rules.
public void SetConditionalFormatting(int row, int column, bool isCombinable, params IConditionalFormattingRule[] rules)
Public Sub SetConditionalFormatting(row As Integer, column As Integer, isCombinable As Boolean, ParamArray rules As IConditionalFormattingRule())
Type | Name | Description |
---|---|---|
int | row | Row index |
int | column | Column index |
bool | isCombinable | Indicates that rule(s) can be merged into an existing conditional format if they affect the same cell range(s). |
IConditionalFormattingRule[] | rules | Rules to apply for the specified cell |
Sets conditional formatting for a specified range of cells on the sheet based on specified rules.
public void SetConditionalFormatting(int row, int column, int rowCount, int columnCount, params IConditionalFormattingRule[] rules)
Public Sub SetConditionalFormatting(row As Integer, column As Integer, rowCount As Integer, columnCount As Integer, ParamArray rules As IConditionalFormattingRule())
Type | Name | Description |
---|---|---|
int | row | Starting row index |
int | column | Starting column index |
int | rowCount | Number of rows |
int | columnCount | Number of columns |
IConditionalFormattingRule[] | rules | Rules to apply for the specified range of cells |
Sets conditional formatting for a specified range of cells on the sheet based on specified rules.
public void SetConditionalFormatting(int row, int column, int rowCount, int columnCount, bool isCombinable, params IConditionalFormattingRule[] rules)
Public Sub SetConditionalFormatting(row As Integer, column As Integer, rowCount As Integer, columnCount As Integer, isCombinable As Boolean, ParamArray rules As IConditionalFormattingRule())
Type | Name | Description |
---|---|---|
int | row | Starting row index |
int | column | Starting column index |
int | rowCount | Number of rows |
int | columnCount | Number of columns |
bool | isCombinable | Indicates that rule(s) can be merged into an existing conditional format if they affect the same cell range(s). |
IConditionalFormattingRule[] | rules | Rules to apply for the specified range of cells |
Sets conditional formatting for a specified ranges of cells on the sheet based on specified rules.
public void SetConditionalFormatting(CellRange[] cellRanges, params IConditionalFormattingRule[] rules)
Public Sub SetConditionalFormatting(cellRanges As CellRange(), ParamArray rules As IConditionalFormattingRule())
Type | Name | Description |
---|---|---|
CellRange[] | cellRanges | Cell ranges |
IConditionalFormattingRule[] | rules | Rules to apply for the specified range of cells |
Sets conditional formatting for a specified ranges of cells on the sheet based on specified rules.
public void SetConditionalFormatting(CellRange[] cellRanges, bool isCombinable, params IConditionalFormattingRule[] rules)
Public Sub SetConditionalFormatting(cellRanges As CellRange(), isCombinable As Boolean, ParamArray rules As IConditionalFormattingRule())
Type | Name | Description |
---|---|---|
CellRange[] | cellRanges | Cell ranges |
bool | isCombinable | Indicates that rule(s) can be merged into existing conditional formatting if they affect the same cell range(s). |
IConditionalFormattingRule[] | rules | Rules to apply for the specified range of cells |
Sets conditional formatting for the sheet.
public void SetConditionalFormatting(params ConditionalFormatting[] cfs)
Public Sub SetConditionalFormatting(ParamArray cfs As ConditionalFormatting())
Type | Name | Description |
---|---|---|
ConditionalFormatting[] | cfs | Conditional formatting |